package com.qf.dao;

import com.qf.model.Loans;
import com.qf.model.MyLoans;
import com.qf.model.PageBean;
import com.qf.model.pojo.Userloans;

import java.sql.Connection;
import java.util.List;

public interface LoansDao {
    //查询所有贷款信息
    List<Loans> findAll();

    //INSERT INTO myloans (l_id,u_id,quota,c_id,u_idcard,type,date,due_date) VALUES(?,?,?,?,?,?,?,?)
    //增加一条贷款信息
    public int addMyLoans(Integer l_id,Integer u_id,Double quota,String c_id);

    //管理员  查询所有待审批贷款
    List<Userloans> findAllMyLoans(PageBean<Userloans> pageBean);

    int sUpdateMyLoans(int l_id);

    MyLoans findMyLoans(int l_id);

    //根据l_id查询贷款产品信息
    Loans findLoans(int l_id);

    //修改贷款信息状态  事务
    int updateMyLoans(Connection conn, int l_id);
}
